package com.classtwo.colleage.conf;

        import com.classtwo.colleage.model.User_attendance;
        import org.springframework.data.jpa.repository.JpaRepository;

        import java.util.List;

public interface DatabaseUser_attendanceInfo extends JpaRepository<User_attendance,Integer> {
    //获取日期所有的数量
    // SELECT * from user_attendance WHERE username='17724247965' AND classnode='SEDMNJDQ'
    List<User_attendance> findAllByUsernameAndClassnode(String username,String classnode);

    // SELECT * from user_attendance WHERE attendance='12018-05-07' AND classnode='SEDMNJDQ'
    List<User_attendance> findAllByAttendanceAndClassnode(String attendance,String classnode);

    // SELECT * from user_attendance WHERE name=' ' AND classnode='SEDMNJDQ'
    List<User_attendance> findAllByNameAndClassnode(String name,String classnode);
}
